Course Name | Database Systems I |
Code | Semester | Theory (hour/week) | Application/Lab (hour/week) | Local Credits | ECTS |
---|---|---|---|---|---|
MBP 101 | Fall | 2 | 0 | 2 | 5 |
Prerequisites | None | |||||
Course Language | Turkish | |||||
Course Type | Required | |||||
Course Level | Short Cycle | |||||
Mode of Delivery | - | |||||
Teaching Methods and Techniques of the Course | ||||||
Course Coordinator | - | |||||
Course Lecturer(s) | ||||||
Assistant(s) | - |
Course Objectives | The purpose of this course is to provide students the basic principles of database systems by also introducing the practical usage of database programming. |
Learning Outcomes | The students who succeeded in this course;
|
Course Description | The content of this course includes the design, implementation and management phases of database server. |
Related Sustainable Development Goals | |
| Core Courses | X |
Major Area Courses | ||
Supportive Courses | ||
Media and Managment Skills Courses | ||
Transferable Skill Courses |
Week | Subjects | Required Materials |
1 | Introduction to Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 1 |
2 | Introduction to SQL | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 2 |
3 | Data Types | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 3 |
4 | Table Creation | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 4 |
5 | Table Creation | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 4 |
6 | Relational Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 5 |
7 | Relational Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 5 |
8 | Midterm | |
9 | Data Grouping | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
10 | Data Grouping | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
11 | Data Filtering | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
12 | Changing the table data | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 7 |
13 | Advanced query techniques and project | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 8 |
14 | Advanced Projects | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 8 |
15 | Reporting | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 9 |
16 | Review of the semester |
Course Notes/Textbooks | Lecture notes and slides, digital programming files. Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). ISBN: 9789756797785 |
Suggested Readings/Materials |
Semester Activities | Number | Weigthing |
Participation | 1 | 10 |
Laboratory / Application | ||
Field Work | ||
Quizzes / Studio Critiques | ||
Portfolio | ||
Homework / Assignments | ||
Presentation / Jury | ||
Project | ||
Seminar / Workshop | ||
Oral Exam | ||
Midterm | 1 | 40 |
Final Exam | 1 | 50 |
Total |
Weighting of Semester Activities on the Final Grade | 2 | 50 |
Weighting of End-of-Semester Activities on the Final Grade | 1 | 50 |
Total |
Semester Activities | Number | Duration (Hours) | Workload |
---|---|---|---|
Course Hours (Including exam week: 16 x total hours) | 16 | 2 | 32 |
Laboratory / Application Hours (Including exam week: 16 x total hours) | 16 | ||
Study Hours Out of Class | 16 | 4 | 64 |
Field Work | |||
Quizzes / Studio Critiques | |||
Portfolio | |||
Homework / Assignments | |||
Presentation / Jury | |||
Project | |||
Seminar / Workshop | |||
Oral Exam | |||
Midterms | 1 | 6 | |
Final Exams | 1 | 8 | |
Total | 110 |
# | Program Competencies/Outcomes | * Contribution Level | ||||
1 | 2 | 3 | 4 | 5 | ||
1 | To be able to have basic computer hardware and software knowledge. | X | ||||
2 | To be able to develop the necessary applications by using internet and network technologies. | X | ||||
3 | To follow developments in the field to adapt to changing conditions. | X | ||||
4 | To be able to conduct experiments in the field and analyze the results. | X | ||||
5 | To be able to use basic programming languages related to the field. | X | ||||
6 | To be able to design and install a computer system that includes software, hardware, or both, meeting the basic needs of the field. | X | ||||
7 | To be able to interpret and follow current developments in the field of computer programming. | X | ||||
8 | To be able to carry professional and ethical responsibility and have awareness of professional ethics in their practices. | X | ||||
9 | To have basic theoretical and practical knowledge about mathematics, computing and computer science. | |||||
10 | To be able to follow the information in the field and communicate with colleagues by using English at the general level of European Language Portfolio A2. | |||||
11 | To be able to direct his/her education to a further level of education |
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest